🕷️️ Job Radar • SCRAPING

peopleperhour.com 2026-04-21 🟡

🔹 Populate Parish Council Data
👤 Client: 🇬🇧 United Kingdom Member since ****
💰 Price: $209
🚩 Problem: Ensure accurate and complete data for UK parishes.
📦 Existing: [Lookup table linking parishes to local authorities]

Specifications:

[Target] Populate an existing Excel list with parish council names, URLs, and contact emails.
[Method] Use a mix of web scraping from council websites, local authority directories, Google Maps, and targeted searches. Validate data through manual checks where necessary.
[UI/UX] Not applicable
[Stack] Python (BeautifulSoup, Selenium), Excel VBA for data manipulation
[Security] Ensure all data sources are publicly accessible; avoid scraping private or restricted sites.
[Format] Standardize data format in Excel: Parish Name | Council Name | URL | Email

Workflow:

1. Review provided lookup table to understand parish-local authority relationships.
2. Automate web scraping from council websites and local authority directories using Python scripts with BeautifulSoup or Selenium.
3. Perform targeted searches on Google Maps for additional information.
4. Cross-reference gathered data against existing 500 validated entries for accuracy.
5. Manually verify critical data points where automation falls short.
6. Standardize and format all collected data in Excel according to specified template.